QVIX Fireworks Inventory System

6-33 Made Available For FTP Download
February 24, 2016

1. We have added in additional support for "Microsoft Windows 10" features.
January 21, 2016
1. We have removed the "Shooters Fee" amount from display/printing when the "Show" preferences are set to "Do not Display/Print Show Totals" in the "Show Invoice".
January 11, 2016
1. We have corrected an minor internal calculation for "Units" and "Cases" when modifiying these amounts in the "Products" window.
January 7, 2016
1. Corrected some discrepancies when "Loading Inventory From a Spreadsheet".
January 5, 2016
1. We have added a new field called "Color" to the "Products" window and the "Load Inventory From Spreadsheet" window.
January 4, 2016
1. We have added in the "Order Number" to the "Customer Order" dropdown box when looking for a "Customer Order" in the "Customer Order" window.
December 21, 2015
1. We have added in a new feature that saves a copy of the "QVIX Fireworks Inventory System.mde" file in the "QVIX Previous Software" folder
in case a user wishes to go back to a previous version of the application.
2. We have corrected the un-necessary prompting for "Customer Number" when printing a "Customer Invoice" from the "Customer Order" screen.
December 15, 2015
1. We have added in "Height, HeightMeters, LiftTime, and Duration" to the "Load Inventory From Spreadsheet (Database)" window.
2. We have added a new field called "Customer Number" to the "Customer" window and all appropriate "Customer" reports.
3. We have added a new field called Supplier Number" to the "Customer" window and all appropriate "Supplier" reports.
4. We have change the procedure for restoring a "QVIX Fireworks Inventory Database" to exit the application after restoring a database.
December 9, 2015
1. We have corrected a problem when the user users a different Drive/Folder than "C:\" for the "QVIX Fireworks Inventory Database", the "License Key" will not be found.
November 4, 2015
1. We have added in the capability for you to give "Customers" a "Supplier(Vendor)" "Discount" for the entire "Vendors Products".
November 1, 2015
1. We have enhanced the P.O.S. display screen with new features.
2. We have rewritten the internal high speed "Product Index Query System" to improve speed and accuracy.
October 20, 2015
1. We have added in the ability to "Save/Update A JPG, AVI, WMV" image/video for a "Product" in the "Products" window for the "QVIX Fireworks Inventory Software System".
2. We have added in the ability to "View/Play A JPG, AVI, WMV" image/video for a "Product" in the "Shows" and "Customer Order" windows for the "QVIX Fireworks Inventory Software System".
3. We have added in the ability to "Save/Update A JPG, AVI, WMV" image/video for a "Product" in the "Shows" window for the "QVIX Fireworks Choreography Software System".
4. We have added in the ability to "View/Play A JPG, AVI, WMV" image/video for a "Product" in the "Shows" window for the "QVIX Fireworks Choreography Software System".
September 30, 2015
1. We have removed any MSACCESS.EXE runtime auto kill process routines from the application.
September 28, 2015
1. We have enhanced the "Product Inventory Totals Report" to display the values clearer.
September 24, 2015
1. We have added in "Date Range" and "Part Number Range" to the "Inventory Report - Compare (In Stock) To (Initial Stock - Sold)" report.
September 23, 2015
1. We have added in "Start Date" and "Include Product Type" selections in the "Product Listing By Location (Up To A Specific Date)" report.
September 22, 2015
1. We have corrected a possible error in the "Shows" screen when not disregarding "Salesperson" as a display field in the "Show".
September 14, 2015
1. We have corrected an error in the "Customer Order" drop down window where the "Order Status" was not displaying after the "Customer's Name" column.
2. We have corrected an error in the "Customer Order" window when selecting "Click To Add New Product Items To Order" box, new items entered would show a error (Reserved field status was incorrect).
September 8, 2015
1. We have added a new field called "Carrier" to the "My Company Information" screen. If not blank, this will override the "My Company Name" used for "Waybill Carrier".
If "Customer Carrier" is not blank, then this will override all previous "Carrier's Names".
2. We have corrected the tabbing order for the "Shipping Address" in the "Customer" screen.
3. We have added in "Salesperson Name" to the "Shows" and "Customer Orders" search windows.
4. We have added in the ability to create new "Shows" and/or "Show Line Items" as a "Bid" instead of a "Reserved Show" using the "Show Preferences" window.
5. We have added in the ability to create new "Orders" and/or "Order Line Items" as a "Bid" instead of a "Reserved Order" using the "Customer Order Preferences" window.
6. We have added in a new "Employee Security Restriction" that allows a non-administrator to "Clear/Set Show/Order "Reserve (Bids)" fields.
7. We have added a new field in "Show/Order" window that only appears for "Bids" and allows the user to "Check" a box marking the "Show/Order" as ready to convert to "Show/Order" from "Bid".
8. We have added an additional selection in the "Select Show Years To Display" dropdown box in the "Shows" window to filter for "Bids Ready To Be Converted To A Show".
9. We have added an additional selection in the "Select Customer Order Years To Display" dropdown box in the "Customer Orders" window to filter for "Bids Ready To Be Converted To A Order".
10. We have corrected the duplicate "1000" pound entry in the "Magazine Weight" dropdown in the "Locations" screen.
11. We have deleted any "BMP" icons and graphics from the inventory software as per "Microsoft's" instructions as Microsoft has dropped support for all "BMP" type graphics in their software.
12. Added "Shipping Expense" and "Choreography Expense" to the "Show Misc. Expenses" selections.
13. We have added in a new table (Window) call "Insurance" to the inventory system.
14. We have added in the ability to automatically calculate the "Show/Order Insurance" to the "Shows" and "Customer Orders" screens.
15. We have corrected all "Report" filter "Windows" for incorrect "Set Selections" loading error.
16. We have added a new report called "List Customer Order Expenses" to the "POS Invoice, Costs, Purchases, Expenses, Payments, Misc." tab in the "Select Your Report" screen.
17. We have added in a new field called "Shooters Fee" to the "Shows" window (Note - This will be used in the "Shooters Scheduling" and "Accounts Receivable" Applications").
18. We have added in the ability to filter for "Bid Ready To Convert To Show/Order" in the "List Show/Order Posting Status" report.
August 22, 2015
1. We have added in 4 new user defined price levels in the "Products" screen.
2. We have added in the ability to assign a "Customer" a user defined "Price Level" for assigning a different price besides "Retail (List) Price".
3. We have modified the "Show" and "Customer Order" screen to use any of the 4 new user defined price amounts in place of the "Retail (List) Price" when assigning "Prices" to the line items in the "Show" or "Customer Order".
August 21, 2015
1. Split "In Stock Amounts (Cases-Units)" into two separate fields "In Stock Cases" and "In Stock Pieces" in the "Load Inventory Data From Spreadsheet/Database" screen.
August 17, 2015
1. Added "Notes (Product Notes)" and "Comments (Line Item Comments)" fields to the "Load Inventory Data From Spreadsheet/Database" screen.
July 20, 2015
1. We have optimized "QVIX Fireworks application Folder" for Cloud sharing.(Please click on 'Select A New QVIX Application Folder Location' in the 'Main Menu' screen)
2. We have added in the ability to use scroll bars on the "Main Menu" screen and other screens when using Windows 8.1 on auto-zoomed screens.
3. We have modified the "Customer Order Invoice' printing module to try and eliminate the extra empty page that some see printing.
July 2, 2015
1. We have decreased the "Horizontal" size of the "Customer Order Invoice" to see if extra pages stop printing on some "Printer" margin settings.
July 1, 2015
1. We have decreased the size of the "Customer Order Invoice" "Disclaimed" font to see if extra pages stop printing on some "Printer" margin settings.
June 24, 2015
1. We have added in the ability to remove "Discontinued" items from the “Click To Add New Product Items To Order” and “Click To Add New Product Items To Show” screens.
June 23, 2015
1. We have corrected a problem where a "Discontinued" item may still display in the new item dropdown list for "Shows/Orders".
2. We have added in the new field "Total Unit(s) & Case(s)" to the "Show" and "Orders" screens.
June 18, 2015
1. We have corrected a problem where all "Reports With Box Numbers" weight were showing the total "Show/Order" weight instead of the actual "Box" weight.
June 9, 2015
1. We have added in additional new fields (Units Reserved, Cases Reserved, Stock-Reserved Units, Stock-Reserved Cases, etc) to the "Create A Stock CSV File" and "Create A Product Excel Spreadsheet File (Sorted By Category Order)" buttons in the "Products" screen.
May 28, 2015
1. We have corrected an error in the "Bill of Lading" reports where the lowest "Placard" needed may not actually be the lowest if the first line item in the "Show/Order" is high than the lowest needed.
May 22, 2015

1. We have re-written all reports that display/print "Weights" to use the same calculation module for these reports.

April 20, 2015
1. We have modified the grouping of the line item detail information for the report "Product Used By Customer" to keep the entire group together.
This should stop the partial printing of the second or third lines for that part number in the "Customer Order Invoice".

April 1, 2015
1. We have modified the "Product Sold/Used By Category" report to account for empty "Unit Prices" when calculating "Cases" totals.

March 31, 2015
1. We have modified the "Product Sold/Used By Category" report to use the "Show/Order" line item prices instead of "Product" screen prices.
March 11, 2015
1. We have added the new fields "Gross Weight" and "Pyro Weight" to the "Products" screen. These new fields, when filled in, over-ride the "Category" corresponding weight fields
for calculating weights for the specific item.
2. We have modified all reports that contain weight calculations to use the new "Product Gross Weight" and "Product Pyro Weight" in their weight calculations.
February 12, 2015
1. We have corrected a problem where the conversion for Pounds to Kilograms was reversed when importing products from a CSV spreadsheet for the "Weight" field.
January 7, 2015
1. We have modified the software to only "Validate the Database" when a new software update is installed thus making the software run faster at startup time.
2. We have added in the ability to use "Move A Group Of Product Items To A New Location" Form In Place of "Move Inventory From All Locations (Except Current) To Current Location" Form
When Using The Main Screen Selection Menu (Enabled/Disabled in the "Set Inventory Product, Move Quantity Offsets And Company Logo" Preferences" screen.
3. We will automatically assume the MS Access top toolbar ribbon is enabled in the application and turn it off.
4. We have corrected a problem where the "Address Line" in both "Customer Invoices" and "The Point of Sale Invoice" is partially blocked by the "Logo" image.
December 30, 2014
1. We have corrected some screen display field sizes when using different screen resolutions.
December 3, 2014
1. We have added the capability of selecting and moving a user defined group of "Line Items" in the "Move Products To/From Locations" screens.
November 24, 2014
1. We have corrected a error in the "Daily Magazine Worksheet Report (Includes Magazine Weights) (ATF Report)" with "Caselot = 0".

November 5, 2014
1. We have modified the "Email A Printed Invoice To The Customer" in the "Customer Order" screen to allow the user to modify the email before it is actually sent to the customer.
2. We have added in the ability to use a "Network Share" besides a "Mapped Drive" when defining a database location in the "Select A New Drive" screen.
3. We have added in the ability to "Create A Product Excel Spreadsheet File (Sorted By Category Order)" in the "Products" screen. This includes "Sales Totals" and "Inventory Totals" columns. This can be used as a basis for creating a spreadsheet for creating a Web based Catalog.

September 4, 2014
1. We have corrected the printing of "Item Type" in the "Customer Order" by "Category" if the printing order is not sent to "Locations".

August 25, 2014
1. We have corrected the grouping of the line items in a "Customer Order" by "Category" if the printing order is not sent to "Locations".

August 20, 2014
1. We have correct some "Location" range screens to show the "Locations" sorted by "Printing Order".
2. We have corrected the "Total Count" amount in the "Shows" and "Customer Orders" screen to account for empty "Amount In Case" entries.

August 3, 2014
1. We have adding in the ability to print the "Customer Order Invoice" sorted by "Location" (Set in the "Customer Order Preferences" screen).

6-31 Made Available For FTP Download

July 28, 2014
1. We have added the ability to define the "Printing Order" for "Magazines (Locations)" in the "Locations" screen.
2. We have added in the ability to print "Customer Order/Show Pull Sheets" sorted by "Magazine Location Printing Order".
3. We have modified all "Reports" that sort by "Location" to use the "Location Print Order" field when sorting/displaying "Reports" by "Location".

July 21, 2014
1. We have added in the ability to auto-set "MS Access Macro Level" to lowset level for MS Access 2007, 2010, 2013.
July 17, 2014
1. We have corrected a problem when printing "Customer Invoices" where the "Caselot (When Enabled)" may not print on the invoice due to a long "Item Description" forcing the "Description" to be truncated.

July 14, 2014
1. We have correct a problem where the case were being converted to units when reserving items in "Shows" and "Customer Order" when using the "Add New Product Items to Shows/Orders" button.

July 10, 2014
1. We have corrected the "Product Sold/Used By Supplier Report" report to allow for empty "Product Descriptions".
2. We have corrected the "Product Sold/Used By CategoryReport" report to allow for empty "Product Descriptions".

June 30, 2014
1. We have added the ability to sort by "Category" in the “Product Used/Sold By Category” report.
2. We have corrected a problem when "Moving Items From One Location to Another" where the "EX Number" is longer than 12 characters in length.

June 6, 2014
1. We have added in "Cases On Order" column to the "Item" dropdown display in the "Shows" screen.
2. We have added in the word "(Demo)" to the serial number on the "Main Menu" screen to advise a user that they are using a "Demo" version of the software/database.

May 28, 2014
1. We have added in the ability to "Print" the "Show/Order/Transfers Summary" screen.
2. We have added in the ability to set a group of blank/empty "Item Manufacters Dates and Shift's" to a "Default Value" in the "Preferences" special screen.

May 27, 2014
1. We have made some additional corrections to the "Daily Magazine WorkSheet" report when using "Inventory Adjustments" entries.

May 20, 2014
1. We have reformatted the "Daily Magazine WorkSheet" report when selecting "Use Comments For Calulations" box is checked.

May 19, 2014
1. We have change the way the error messages are calculated in the system that identifies when the "QVIX Fireworks Inventory Database" is either not accessible or set to "Read Only".
2. We have added in some new interal table verifications to the "Daily Magazine WorkSheet" report.

May 18, 2014
1. We have temporarily turned off the error messages to the system to help identify when the "QVIX Fireworks Inventory Database" is either not accessible or set to "Read Only".

May 14, 2014
1. We have corrected for a rounding error in the "Initial Cases" column in the "Daily Magazine WorkSheet" report.
2. We have addede in the ability to automatically save the last part number used throughout the system and use a "One Click" Icon to repeat this number in a "Part Number" location or range.
3. We have added some new error messages to the system to help identify when the "QVIX Fireworks Inventory Database" is either not accessible or set to "Read Only".

May 11, 2014
1. We have added in a new utility that "Compares Initial Quantities With Stock In Stock Quanties And Sold Items And Adjust If Needed".
2. We have corrected a error in the "Daily Magazine WorkSheet" when a item has multiple caselot quanties that contain different amounts of units in case.

May 4, 2014
1. We have corrected the "Daily Worksheet" report to allow for the use of "Comments in it's Calculations".

May 1, 2014
1. We have added in a new report named "Product Disposition Report (Sorted By Location)".
2. We have enhanced the report named "Product Disposition Report (Sorted By Location)" with a new field called Show/Order Number".
3. We have enhanced the report named "Product Disposition Report (Sorted By Customer)" with a new field called Show/Order Number".
4. We have enhanced the report named "Product Disposition Report" with a new field called Show/Order Number".
5. We have enhanced the report named "Daily Magazine WorkSheet" by adding in a new line entry containing the inventory totals before the previous start date, when selecting a date range.

April 29, 2014
1. We have added in the capability to display a message "Have You Checked Your Posting Date" to the "Shows" and "Customer Orders" screens when "Posting" line items.

April 28, 2014
1. We have grouped all "Customer Order Messages" in the "Customer Order Preferences" screen to a new seperate screen containing all user defined messages.

April 25, 2014
1. We have added in the ability to create special messages in the "Customer Order Invoice" report for "Order Posted", "Order Partially Posted", "Order Not Posted".
These messages can be printed in "Black, Red, Green, or Blue" when set in the "Customer Information and Custoer Order Preferences" screen.

April 24, 2014
1. We have released a new software licensing schema making it easier for the customer to update their QVIX software licenses.
2. We have added in the capability to Auto-Save a new "Customer/Sponser" information when creating a new "Customer Order" or "Show" when you Double-Clock" the "Customer" or "Sponsor" field box.
3. We have removed the ability to select the "Old Style Bill of Lading" from the "Preferences" screen as this format is now obsolete by the "D.O.T.".
4. We have added in a new "Bill of Lading" alternate form that can be selected in the "Preferences" screen.
5. We have grouped the printing selections for the "Show" screen, "Customer Order" and "Transfer" screens for better clarity.
6. We have corrected minor message errors in the "Main Menu" screen.
7. We now support Excel Spreadsheet ".xslx" file extensions in both "Shows", "Customer Orders" and "Transfers" for creating and loading Excel Spreadsheets.
8. We have added "Total Product", "Total Customer", "Total Show" and "Total Customer Order" counts to the "Main Menu" screen. (Only for Administrator Users).

6-29 Made Available For FTP Download
April 15, 2014
1. We have corrected a problem where the "Customer Order" were being displayed even when the check box was unchecked in the "List Shows By Month" report.

April 14, 2014
1. We have added the capability to Display/Print "Emergency Response Information/Plans" for "1.1G, 1.2G, 1.3G, 1.4G, 1.4S" Image/PDF formatted documents in the "Shows" screen.
These items are defined in "My Company Information" screen.

March 28, 2014
1. We have enhanced the "List Shows By Month" report to optionally include "Orders" with "Shows" and also sort by "Date" besides sort by "Show/Order Name".

March 25, 2014
1. We have updated the D.O.T. EX Approved numbers for product evaluation in this new release.

March 24, 2014
1. We have corrected the "Location" selection in the "List Products By Magazine Location (Prints Magazine Weights Used By ATF) (ATF Report)" report so it only reports on the "Locations" you have selected for your report.

March 12, 2014
1. We have added a new selection into the "Click To Set Inventory Product Defaults, Move Quantity Offsets And Company Logo" "Preferences" tab called "Check Box To Enable The Purchase Order To Receive Stock As Pieces (Cases * Caselot) Instead Of Cases".
2. We have added a new feature to the "Purchase Order" screen to allow for posting of either "Units" or "Cases" to inventory, based on the mode the user selects.

March 4, 2014
1. We have a new report named "List Shows By Month (Including Product Used)" in the "Lot Number Usage, Shows, Devices" group.
2. We have modified the "Product Price List/Cost By Location" report to take into account the "Purchase Order Line Costs" when calculating costs for the report.
3. We have modified the "Product Inventory Cost Totals (As Of Report Date)(Based On In Stock Quantities)" report to take into account the "Purchase Order Line Costs" when calculating costs for the report.

February 20, 2014
1. We can now load inventory items from a spreadsheet using "Column Heading Names" in the "Load Inventory Data From Spreadsheet/Database" module.
2. We have a new report named "Product Listing By Location (Up To A Specific Date)" in the "Product Sales and Magazine Locations" group..
3. We have added in some new enhancements to the high speed "Point of Sale" module.

November 5, 2013
1. We have modified the ATF reports to remove any line items that have Units=0 and Cases=0 to make the reports clearer.
2. We have added in a new inventory stock quantity modification screen in the "Enter/View Other Information" screen called "Inventory Magazine Reconciliation".
This new screen will make it easier for a user to compare and make manual updates to their magazine item amounts after taking a physical inventory.

October 7, 2013
1. We have added in the new "Hazard Class" "1.2G" to the Products screen.

October 2, 2013
1. We have added in a new "Initial Quantity Validation Check and Update" module in the "Click To Go To Data Validation/Testing Screen" in "My Preferences" screen.
2. We have corrected a problem where the "Initial Quantities" in "Shows" and "Customer Orders" may set this field to a empty amount.

3. We have added in a new report called "Product Inventory Totals Report (With Purchase Order Received and Posted Totals)" in the "POS Invoice, Costs, Purchases, Expenses, Payments, Misc."

September 25, 2013
1. We have added in a new report called "Product Inventory By Location Report (Includes Location and Item Weight, Hazard Class, UN Number"" in the "Product Price Lists Reports" tab.

September 24, 2013
1. We have added the "Comments" field to "Create A In Stock CSV File" in the "Products" screen.

September 20, 2013
1. We have corrected a problem where extra "Stock Entry Lines" with zero stock amounts were created when "Moving Shows, Orders, Transfer to a Reserve Location"
2. We now show the first "Year Active Show Entry" when selecting a "Different Year Selection to Display" in "Shows" and "Customer Orders"."

September 3, 2013
1. We have added in a new high speed capability called "Point of Sale" to the "QVIX Fireworks Inventory System".
This new feature supports auto-posting of the line items and accepts direct "Laser Scanner" data entries.
The line entries will auto-match the closest part numbers as the entry is keyed in.
We also support automatic discounted entries such as:
A. Buy 1 Get 1 Item Free
B. Buy 1 Item, Get 1 Item at 50%
C. Buy 2 Items, Get 1 Item Free.
2. We have added in a new "Promo Code" feature to the "Point of Sale" module. This handles "Promotional Discounts and Coupons for the P.O.S. Customers".
3. We have added in a new "My Preferences (Point of Sale) capability to the "QVIX Fireworks Inventory System".
4. We have added a new "Inventory Used In Show/Orders Report (By Show/Order Date)" report.
5. We have enhanced the "Product Inventory Cost" report and rename it "Product Inventory Cost Totals Report (Based On Initial Stock - Quantity Sold)".
6. We have enhanced the "Product Inventory Cost Totals (As Of Report Date)" report and rename it "Product Inventory Cost Totals (As Of Report Date)(Based On In Stock Quantities)".